Generates from cell ranges.
Syntax
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As SpreadChart
Dim sheetView As SheetView
Dim cellRanges() As CellRange
Dim autoSwitch As Boolean
instance.GenerateFromCellRanges(sheetView, cellRanges, autoSwitch) |
Parameters
- sheetView
- The sheet view.
- cellRanges
- The cell ranges.
- autoSwitch
- if set to
true, the processing will switch rows and columns automatically if necessary.
Remarks
Example
This example uses the GenerateFromCellRanges method.
| C# | Copy Code |
|---|
FarPoint.Win.Spread.Model.CellRange celRange1 = new FarPoint.Win.Spread.Model.CellRange(0, 0, 7, 2);
FarPoint.Win.Spread.Model.CellRange celRange2 = new FarPoint.Win.Spread.Model.CellRange(0, 2, 7, 2);
FarPoint.Win.Spread.Chart.SpreadChart chart = new FarPoint.Win.Spread.Chart.SpreadChart(typeof(FarPoint.Win.Chart.BarSeries));
chart.GenerateFromCellRanges(fpSpread1.Sheets[0], new FarPoint.Win.Spread.Model.CellRange[] { celRange1, celRange2 }, true);
fpSpread1.Sheets[0].Charts.Add(chart); |
| Visual Basic | Copy Code |
|---|
Dim celRange1 As New FarPoint.Win.Spread.Model.CellRange(0, 0, 7, 2)
Dim celRange2 = New FarPoint.Win.Spread.Model.CellRange(0, 2, 7, 2)
Dim chart As New FarPoint.Win.Spread.Chart.SpreadChart(GetType(FarPoint.Win.Chart.BarSeries))
chart.GenerateFromCellRanges(FpSpread1.Sheets(0), New FarPoint.Win.Spread.Model.CellRange() {celRange1, celRange2}, True)
FpSpread1.Sheets(0).Charts.Add(chart) |
Requirements
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
See Also
